Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | TankProbe(AS_PBE_TNK) |
TankID (FK)(PK) | A unique identifier for this Tank | ID_TNK | Identity | integer | TankProbe(AS_PBE_TNK) |
TankProbeID (FK)(PK) | A system assigned unique identifier for the TankProbe | ID_PBE_TNK | Identity | integer | TankProbe(AS_PBE_TNK) |
ReadingNumber (PK) | A unique identifier for this particular reading on this TankProbe | AI_RDG | LineNumber | smallint | |
DateTimeStamp | The date & time the reading was taken | TS_RDG | AuditDateTime | datetime | |
ProductLevel | The measured level of the product in the Tank | QU_LV_PDT | Quantity | DECIMAL(9,3) | |
TotalObservedVolume | The volume of product (including free water) in the tank. | QV_OBS | Quantity | DECIMAL(9,3) | |
GrossStandardVolume | The volume, excluding the free water in the tank, corrected to reference temperature. | QV_GS_STD | Quantity | DECIMAL(9,3) | |
AverageTemperature | The average temperature of the product in the tank | QU_TEMP_AV | Quantity | DECIMAL(9,3) | |
ObservedDensity | The average density of the product | QU_DNSTY_OBS | Quantity | DECIMAL(9,3) | |